Python GUI Programming Cookbook, Third Edition by Burkhard Meier

Author:Burkhard Meier
Language: eng
Format: mobi, epub
Tags: COM087020 - COMPUTERS / Desktop Applications / Design and Graphics, COM051360 - COMPUTERS / Programming Languages / Python, COM012000 - COMPUTERS / Computer Graphics
Publisher: Packt
Published: 2019-10-11T11:25:44+00:00

Storing Data in Our MySQL Database via Our GUI

In this chapter, we will learn how to install and use a MySQL database and connect it to our GUI.

MySQL is a full-fledged Structured Query Language (SQL) database server and comes with a very nice GUI of its own so that we can view and work with the data. We will create a database, insert data into our database, and then see how we can modify, read, and delete data.

Data storage in a SQL database is essential for software programs written in Python. All of our data currently only exists in memory and we want to make it persistent so that we do not lose our data once we close our running Python program.

Here, you will learn how to increase your programming skills by adding SQL to your programming toolbox.

The first recipe in this chapter will show you how to install the free MySQL Community Edition.

After successfully connecting to a running instance of our MySQL server, we will design and create a database that will accept a book title, which could be our own journal or a quote we found somewhere on the internet. We will require a page number for the book, which could be blank (NULL in SQL terms), and then we will insert the quote we like from a book, journal, website, or a friend into our MySQL database using our GUI, which we built using Python 3.7 or later.

We will insert, modify, delete, and display our favorite quotes using our Python GUI to issue these SQL commands and to display the data.

CRUD is a database term you may have come across before that is an abbreviation for the four basic SQL commands, that is, Create, Read, Update, and Delete.

Here is an overview of the Python modules for this chapter:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.